Release 10.1A: OpenEdge Data Management:
Database Administration

PROUTIL SETTABLECREATELIMIT qualifier

Set the create limit for the specified table.

Syntax

proutil db-name -C settablecreatelimit table-name create-limit

Parameters

db-name

Specifies the database where you are setting the create limit.

table-name

Specifies the table where you are setting the create limit.

create-limit

Specifies the new create limit. The create limit is the amount of free space that must remain in a block when you are adding a record to the block.

Notes

For a Type II area, SETTABLECREATELIMIT sets the table create limit for the specified table. For a Type I area, SETTABLECREATELIMIT issues a warning that all tables and BLOBs in an area must have the same create limit, and prompts you to confirm setting the create limit for all tables and BLOBs in the area containing the specified table.
The create limit value must be greater than 32 and less than the block size minus 128 bytes.
For databases with a 1K block size, the default create limit is 75. For all other database block sizes, the default create limit is 150.
The database must be offline when setting create limits.
For more information on setting create limits, see the "Database fragmentation" section.